package com.kb.design.mapper.postgreSQL;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.kb.design.entity.DesignUserPost;
import com.kb.design.entity.DesignUserRole;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 订单表(DesignOrder)表数据库访问层
 *
 * @author makejava
 * @since 2023-11-24 10:56:46
 */
@Mapper
public interface DesignUserRoleMapper extends BaseMapper<DesignUserRole> {

    @Select("SELECT * FROM design_user_role  WHERE user_id = #{userId}")
    public List<DesignUserRole> queryUserRole(Long userId);
//
//    @Select("SELECT u.name , u.code ,p.post_id FROM design_user u left join design_user_post p on p.user_id = u.id WHERE u.status = '0' and del_flag = '0'")
//    public List<DesignUserPost> queryAllUserPost();
}

